package com.ruoyi.tranShort.mapper;

import java.util.List;
import java.util.Map;

import com.ruoyi.tranShort.domain.SchedulingDetailStartAndEnd;
import com.ruoyi.tranShort.domain.ShortSchedulingDate;
import com.ruoyi.tranShort.domain.ShortSchedulingDetail;
import com.ruoyi.tranShort.domain.ShortSentryPost;

/**
 * 排班明细Mapper接口
 * 
 * @author ruoyi
 * @date 2021-08-14
 */
public interface ShortSchedulingDetailMapper 
{
    /**
     * 查询排班明细
     * 
     * @param id 排班明细主键
     * @return 排班明细
     */
    public ShortSchedulingDetail selectShortSchedulingDetailById(Long id);

    /**
     * 查询排班明细列表
     * 
     * @param shortSchedulingDetail 排班明细
     * @return 排班明细集合
     */
    public List<ShortSchedulingDetail> selectShortSchedulingDetailList(ShortSchedulingDetail shortSchedulingDetail);

    /**
     * 新增排班明细
     * 
     * @param shortSchedulingDetail 排班明细
     * @return 结果
     */
    public int insertShortSchedulingDetail(ShortSchedulingDetail shortSchedulingDetail);

    /**
     * 修改排班明细
     * 
     * @param shortSchedulingDetail 排班明细
     * @return 结果
     */
    public int updateShortSchedulingDetail(ShortSchedulingDetail shortSchedulingDetail);

    /**
     * 更新
     * @param map
     * @return
     */
    int updateShortSchedulingDetailByTimeAndDateId(Map<String,Object> map);

    /**
     * 删除排班明细
     * 
     * @param id 排班明细主键
     * @return 结果
     */
    public int deleteShortSchedulingDetailById(Long id);

    /**
     * 批量删除排班明细
     * 
     * @param ids 需要删除的数据主键集合
     * @return 结果
     */
    public int deleteShortSchedulingDetailByIds(Long[] ids);

    /**
     * 根据SchedulingDateId查询
     * @param id
     * @return
     */
    List<ShortSchedulingDetail> selectShortSchedulingDateAndPersonBySchedulingDateId(Long id);

    /**
     * 根据id查询时间段
     * @param id
     * @return
     */
    List<SchedulingDetailStartAndEnd> selectStartAndEndByGroupAndSchedulingDateId(Long id);

    /**
     * 根据iSchedulingDateIdd查询哨位
     * @param id
     * @return
     */
    List<ShortSentryPost> selectSentryPostIdListByGroupAndSchedulingDateId(Long id);

    /**
     * 查询出指定时间段内的人员
     * @param map
     * @return
     */
    List<ShortSchedulingDetail> selectShortSchedulingDateAndPersonBySchedulingDateIdAndTime(Map<String,Object> map);

    /**
     * 查询出单个对象
     * @param shortSchedulingDetail
     * @return
     */
    ShortSchedulingDetail selectShortSchedulingDateOneBySchedulingDateIdAndTime(ShortSchedulingDetail shortSchedulingDetail);

    /**
     * 根据SchedulingDateId删除
     * @param id
     * @return
     */
    int deleteShortSchedulingDetailBySchedulingDateId(Long[] id);

    /**
     * 根据SchedulingDateId查询ShortSchedulingDetailId
     * @param id
     * @return
     */
    Long[] selectShortSchedulingDetailIdBySchedulingDateId(Long[] id);

    /**
     * 删除
     * @param shortSchedulingDetail
     * @return
     */
    int deleteSHortSchedulingDetailBySchedulingDate(ShortSchedulingDetail shortSchedulingDetail);

    /**
     * 查询
     * @param ShortSchedulingDetail
     * @return
     */
    Long[] selectShortSchedulingDateBySchedulingDateIdAndTime(ShortSchedulingDetail ShortSchedulingDetail);
}
